﻿CREATE PROCEDURE [branding].[GetValueById]
	@valueId int
AS
	select	bv.ID,
			CAST('value' as varchar(10)) as ObjectType,
			bv.Tag,
			bv.SubTag,
			bv.ResourceId,
			bv.Brand,
			bv.ContentLength,
			bv.TypeName,
			bv.SerializedValue
	from	branding.Value as bv
	where	bv.ID = @valueId;
RETURN 0